06. Workspace: DVD Rental Database

Start Querying Your Data

The database Entity Relationship Diagram was provided at the start of this lesson, but you can also download it below. Now you can start querying your database!

First, we could have a look at all the data from the Film table:

SELECT * FROM Film;

Your first query, AWESOME!

Now check out what's in the Actor table.

SELECT * FROM Actor;

Looks like you are ready to take on this PROJECT! Everything you have been studying is going to come in handy now!

A quick note: You can ignore the "last_update" column in the tables, as that column is part of the Sakila database but we will not be using it.

Note: If the proper tables for the DVD Rental Database do not appear for some reason in the Schema below, you can fix this using the Menu in the lower left of the workspace. Make sure you have first saved any query you have entered, then click on Menu, then choose Reset Data, and type in "Reset Data" as directed. This will definitely bring up the proper schema tables for the DVD Rental Database.